UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rL+cMMZ8a/187WohhKiHoyqBze+F3JCf+qHSJBs9T60='
WHERE
key_id = '27b343cd0200ae84a77cd857e9d795e4d8a38f7d10c60548148ccb09c92380b4'
AND (
token = 'rL+cMMZ8a/187WohhKiHoyqBze+F3JCf+qHSJBs9T60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)