UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/0/145isvPq7mygU9p8HqcwMp/d8SRnZRKN1PqZ0eiA=' 
WHERE 
  key_id = '23e0124ca4ac429fd9d498d35d61c075b298c4b331e1c2944245704053075965' 
  AND (
    token = '/0/145isvPq7mygU9p8HqcwMp/d8SRnZRKN1PqZ0eiA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033