UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aXgLC2YOp5DqQy8trG/DtGQn71Tkxw2IDGQ9n1EsJqI=' 
WHERE 
  key_id = '7e92c0959798af3d1ca99312a49f93251ff36e10e762351935d5f1a939b9afcf' 
  AND (
    token = 'aXgLC2YOp5DqQy8trG/DtGQn71Tkxw2IDGQ9n1EsJqI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029