UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nYhKEX3LK+vlWkUBPi+QGyTGA1I94BY+1N/elcEN9zA='
WHERE
key_id = 'd8041a9c1e299fc99a62a68db0a138b93052ec69e8b2bef7d8cc725afb8c2775'
AND (
token = 'nYhKEX3LK+vlWkUBPi+QGyTGA1I94BY+1N/elcEN9zA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)