UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oShJzEClfOeijMDWbmnvzvAPVoXQae4U2ZqmCpIbels='
WHERE
key_id = '18e1840625037c6124705d6057fb281d9f603161450ba606666ea21759f11e5d'
AND (
token = 'oShJzEClfOeijMDWbmnvzvAPVoXQae4U2ZqmCpIbels='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)