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