UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oaoXVvokCbWq7/mrSIKJVc0WVx+OMgUAci3TJI6Acjw='
WHERE
key_id = 'a823a1518069c7cbf62884594c5231278ac36337aff1aadd4c5388d6a32dceb7'
AND (
token = 'oaoXVvokCbWq7/mrSIKJVc0WVx+OMgUAci3TJI6Acjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)