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