UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AnLd49KiHGpDxCoOuTF9Gep4+7w2xvKoUzamRqJI6PM=' 
WHERE 
  key_id = '810f25f9e8f36d2e9cdd508793dde37dedd21da625fe4398610d2812236ea6cb' 
  AND (
    token = 'AnLd49KiHGpDxCoOuTF9Gep4+7w2xvKoUzamRqJI6PM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032