UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YX8yTUBq7oM3yNzrDMwXDjQoZO6xPfsweYK2GlWkNPY='
WHERE
key_id = 'c3445f5d8209145f98ab6eb11d3593e01fabe4f18517dfb3be105a32ee080fa7'
AND (
token = 'YX8yTUBq7oM3yNzrDMwXDjQoZO6xPfsweYK2GlWkNPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)