UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfPZ7qs2y16eIaRinbPmOXTiW8D6d+8skbwAngGtwDY='
WHERE
key_id = '1df5dfafede8d3c62e7c9251b124a9988ba004694bc3482f4384f4019029bee8'
AND (
token = 'pfPZ7qs2y16eIaRinbPmOXTiW8D6d+8skbwAngGtwDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)