UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnNcGyGpYGPghakSDfCG3/UX/wySUMu7pu5aOdvIkIY='
WHERE
key_id = 'c93581ae1f93b42e84023394487f912ea79e5134b99d355c516ed85755bb1e5d'
AND (
token = 'ZnNcGyGpYGPghakSDfCG3/UX/wySUMu7pu5aOdvIkIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)