UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vq9pxgHmW6r0wP7Im/SEwfJw7A4N3j2aesQjLYYSpcw='
WHERE
key_id = 'aff1a9ccfe81be641eec2d224d439895345ab29d189e0ad9a570714083293678'
AND (
token = 'vq9pxgHmW6r0wP7Im/SEwfJw7A4N3j2aesQjLYYSpcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)