UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZpucmxWb+N2o0+c2IjQgbxS00/zbJ0nkY5235ahx6AM=' 
WHERE 
  key_id = '7158ca5b1e288737b8feaea5f0780cf1f5fbe5ed67848926393a5a9f48f83e31' 
  AND (
    token = 'ZpucmxWb+N2o0+c2IjQgbxS00/zbJ0nkY5235ahx6AM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030