UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+qH1tZ6IyehfxefMT+kju4Bq42UxBtBlD/J0L9G+iIw=' 
WHERE 
  key_id = 'b480fe7fdc6fe58f5e55f07638821cb33fc7f64454a46477e54a0775f9bd4692' 
  AND (
    token = '+qH1tZ6IyehfxefMT+kju4Bq42UxBtBlD/J0L9G+iIw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052