UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QVWca0z/0+FcgsNNt0DZTWH422lVFdmWUVXytWfLOYs='
WHERE
key_id = '97746b5e686871c0faa4adc5ab1988bd049d9bf8ac1ba2caef1bd8df90569fe5'
AND (
token = 'QVWca0z/0+FcgsNNt0DZTWH422lVFdmWUVXytWfLOYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)