UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dMoxE6ZtNPV50V22W7kPGvnGPvXqd7nEVDxiEA1rwfs='
WHERE
key_id = '199646f67a5366f8a06f46f2a99060c7543f9a8522f0889abdd82b602c65c939'
AND (
token = 'dMoxE6ZtNPV50V22W7kPGvnGPvXqd7nEVDxiEA1rwfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)