UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LopnV6IqEejW7B3ze9W65QNbjIN8B9jV2SujLH5frRk=' 
WHERE 
  key_id = 'c5cbcc469ae95334c0228bf64cf58ba492d48d33f132c50658b26f9ed06e229a' 
  AND (
    token = 'LopnV6IqEejW7B3ze9W65QNbjIN8B9jV2SujLH5frRk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034