UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lXtzgyXLMPbYXXySOVCPAbFhFnOni3wCglTRDG3NEBc='
WHERE
key_id = 'b518a9462e3c9beb6ea288659968c66328d07aa26c6c4f99a4524aa5ac465b18'
AND (
token = 'lXtzgyXLMPbYXXySOVCPAbFhFnOni3wCglTRDG3NEBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)