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