UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Ad6wyCA2Uuo0fOXq50c0peuPzX1K4K3W5vhBMyJHME='
WHERE
key_id = '7e8904acd7864c285fb13974ebdaac25777eba4ed8103548e744c8c25e8ef7dd'
AND (
token = '2Ad6wyCA2Uuo0fOXq50c0peuPzX1K4K3W5vhBMyJHME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)