UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1PaeHj/V4AQoZdRON4iEAwiK6kjXMwrRWQaQc2RAAHg='
WHERE
key_id = '28564bf335a0cb65a5d64cd767081c77cd34f943b7d463bc1d8598d2176d3325'
AND (
token = '1PaeHj/V4AQoZdRON4iEAwiK6kjXMwrRWQaQc2RAAHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)