UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '79Nvv8X1J1eGRh/CUKeqv6kzkzwWF25C/kvnzcvWfnI='
WHERE
key_id = '165f882a2fd4d686af715b09b13e6dacf64d9fa748f838eccd182527080c42ef'
AND (
token = '79Nvv8X1J1eGRh/CUKeqv6kzkzwWF25C/kvnzcvWfnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)