UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZKOAgALBuk+V1K1xr5mME3ZjNDxZkrwibv5v0N/g88g=' 
WHERE 
  key_id = '61d3d566418088defd89761a1999b51f37e2360d1e6108a6c4cfa12b5bc15400' 
  AND (
    token = 'ZKOAgALBuk+V1K1xr5mME3ZjNDxZkrwibv5v0N/g88g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022