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