UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f8n5/HhDEff9huwZspq6iyXmo+qYixOZ+u2t+c4mey4='
WHERE
key_id = 'dc6f123c3303d0fe9c0420860f5bb535e44b820963abe57309383eb9edccaebd'
AND (
token = 'f8n5/HhDEff9huwZspq6iyXmo+qYixOZ+u2t+c4mey4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)