UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ActfhYnoIyFzsQE0etXtSYyRRrAc8KjOG4pvncAUlYA='
WHERE
key_id = '65611fc78d31c4da4a6229f30a8d8bf00e238b11cc34a01788fb1620423fc2f5'
AND (
token = 'ActfhYnoIyFzsQE0etXtSYyRRrAc8KjOG4pvncAUlYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)