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