UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nv+ro6UH6DHy1igTTvF46JnRPWg6RR/z4A5/sWS17Sw='
WHERE
key_id = '6067899aa81758b1d8ae2c0ad28f4bc894240c80f76c5cb0a5fae3fe83ee69f6'
AND (
token = 'nv+ro6UH6DHy1igTTvF46JnRPWg6RR/z4A5/sWS17Sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)