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