UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EsE22QaMymm4GhFPxvsmjqBSZ0EPspmUwiLGH1vr9TM='
WHERE
key_id = '165149635ee293c76e6fa4313ac0a74e3a21f58e2bc20bcb100600ced17c4ed7'
AND (
token = 'EsE22QaMymm4GhFPxvsmjqBSZ0EPspmUwiLGH1vr9TM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)