UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BgOuhYr1t+zRqmwOtOsuHB3ID1QTmYwRBLXcjzEq6HE=' 
WHERE 
  key_id = '416025c893ce5859c6637f808e6306a5e64e6e301e93edcc8186336d5135ff1c' 
  AND (
    token = 'BgOuhYr1t+zRqmwOtOsuHB3ID1QTmYwRBLXcjzEq6HE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035