UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e7HL5FPmC9OzEa7qcrXRRv1NSi7AuwarM0GFLoHssms='
WHERE
key_id = '977b4b63c299a847be597639a634328ed1e305ee5374954b8dfb5a2678524a45'
AND (
token = 'e7HL5FPmC9OzEa7qcrXRRv1NSi7AuwarM0GFLoHssms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)