UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'trfvGfdCKXfidCAZwYcTeJQP2daBWzJS21HJLkGeRAk='
WHERE
key_id = '1d7de2035baa7379d81597c09b26f44c9e72cac265102874ca69e3b8de3e5a23'
AND (
token = 'trfvGfdCKXfidCAZwYcTeJQP2daBWzJS21HJLkGeRAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)